Labels:text | screenshot | font OCR: Transaction Fact Table Product Product key Store dimension Store_key dimension Customer_key Customer. dimension Sales ticket key Sales ticket dimension Time key Time Quantity sold dimension Dollars sold Figure 1. A typical star join schema for a set of retail sales trans- actions. Each fact table record is a line item on a particular customer ticket. In this article, I show how to add a sixth "causal" dimension that explains why the sale took place.
(2000).iso/dbmsa/nov96/kimbf101.gif){kind=small}
(2000).iso/dbmsa/nov96/3p22.gif){kind=link}
(2000).iso/dbmsa/nov96/kimbf102.gif){kind=link}